﻿CREATE TABLE [dbo].[CustomerInCategories] (
    [CustomerID] INT NOT NULL,
    [CategoryID] INT NOT NULL,
    PRIMARY KEY CLUSTERED ([CustomerID] ASC, [CategoryID] ASC),
    CONSTRAINT [FK_customer_in_category_customer_categories] FOREIGN KEY ([CategoryID]) REFERENCES [dbo].[CustomerCategories] ([ID]) ON DELETE CASCADE,
    CONSTRAINT [FK_customer_in_category_customers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[Customers] ([ID]) ON DELETE CASCADE
);

